﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="classCount.aspx.cs" Inherits="学生成绩查询及选课系统.admin.classCount" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>学生成绩查询及选课系统</title>
    <meta name="renderer" content="webkit|ie-comp|ie-stand"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />
    <meta http-equiv="Cache-Control" content="no-siteapp" />
    <link rel="stylesheet" href="../css/font.css"/>
    <link rel="stylesheet" href="../css/xadmin.css"/>
    <link href="./StyleSheet1.css" rel="stylesheet" />
    <!-- <link rel="stylesheet" href="./css/theme5.css"> -->
    <script src="../lib/layui/layui.js" charset="utf-8"></script>
    <script type="text/javascript" src="../js/xadmin.js"></script>

</head>
<body>
    <%--<div class="layui-card-body ">--%>
    <div class="layui-card-body ">
        <form id="form1" runat="server">
            <asp:GridView ID="GridView1" CssClass="layui-table layui-form" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="班号" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" Width="500px" RowStyle-Height="30px">
                <AlternatingRowStyle BackColor="White" />
                <Columns>
                    <asp:BoundField DataField="班名" HeaderText="班名" SortExpression="班名" />
                    <asp:BoundField DataField="班号" HeaderText="班号" ReadOnly="True" SortExpression="班号" />
                    <asp:BoundField DataField="班级人数" HeaderText="班级人数" ReadOnly="True" SortExpression="班级人数" />
                </Columns>
                <EditRowStyle BackColor="#7C6F57" />
                <FooterStyle BackColor="#1C5E55" Font-Bold="True"  ForeColor="White" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#E3EAEB" />
                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                <SortedAscendingCellStyle BackColor="#F8FAFA" />
                <SortedAscendingHeaderStyle BackColor="#246B61" />
                <SortedDescendingCellStyle BackColor="#D4DFE1" />
                <SortedDescendingHeaderStyle BackColor="#15524A" />
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:C#StuentManageConnectionString %>" SelectCommand="select classname as '班名',class.classno as '班号',count(class.classno) as '班级人数' from class join student on student.classno=class.classno group by class.classno,classname,class.clastate having class.clastate=1"></asp:SqlDataSource>

        </form>
      </div>
    <%-- </div>--%>
</body>
</html>
